INV Transaction Source Types – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
None
Report Parameters
Source, Show DFF Attributes
Oracle EBS Tables Used
Report Categories
Related Reports
INV Transaction Historical Summary, CAC WIP Jobs With Complete Status Which Are Ready for Close, CAC AP Accrual IR ISO Match Analysis, CAC Internal Order Shipment Margin
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | INV Transaction Source Types 20-Jul-2024 235051.xlsx |
| Blitz Report™ XML Import | INV_Transaction_Source_Types.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/inv-transaction-source-types/ |
INV Transaction Source Types - Case Study & Technical Analysis
Executive Summary
The INV Transaction Source Types report is a system configuration report. In Oracle Inventory, every transaction has a “Source Type” that defines where the transaction originated (e.g., “Purchase Order”, “Sales Order”, “Account”, “Job or Schedule”). This report lists these system-defined sources.
Business Challenge
Understanding the “Source” of a transaction is key to understanding the business process.
- Reporting: When building custom reports, developers need to know that Source Type 1 = “Purchase Order” and Source Type 2 = “Sales Order”.
- Validation: Users need to know which sources are available when defining new Transaction Types.
Solution
The INV Transaction Source Types report lists the values from MTL_TXN_SOURCE_TYPES. These are mostly seeded (system-defined) values that cannot be changed, but they are critical for reference.
Key Features:
- ID Mapping: Shows the numeric ID and the user-friendly name.
- Validation: Used as the validation set for the “Source” field in many other forms.
Technical Architecture
The report queries the seed data table.
Key Tables and Views
MTL_TXN_SOURCE_TYPES: The table storing the source definitions.
Core Logic
- Retrieval: Selects all records from the table.
- Display: Lists the ID, Name, and Description.
Business Impact
- Developer Aid: Essential reference for anyone writing SQL queries against
MTL_MATERIAL_TRANSACTIONS. - System Understanding: Helps users understand the different “origins” of inventory demand and supply.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics